What does Keyword STATS Indicates in Backup Scripts in SQL Server?

Question

Sushant Mishra · Answer

It displays a message of percentage
complete when the backup is in process mode. its default value of the stats is
10 and hence if we do not specify the stats, keywords, SQL Server displays the
percentage completion at every 10 percentage.
BACKUP DATABASE [School_Context]
TODISK = N'D:\a' WITH FORMAT,STATS = 20GOIt will give output as

interview

What does Keyword STATS Indicates in Backup Scripts in SQL Server?

Sushant Mishra

Can you answer this question?

1 Answers

Liked By